<HTML>
<HEAD>
<TITLE>TABLE INFO</TITLE>
<LINK href="style.css" rel=stylesheet type=text/css>
</HEAD>
<BODY class=bodyTab>
&nbsp;<BR>

<TABLE border=1 cellspacing=0 cellpadding=3>
<TR class=trTab1><TD nowrap>Physical name</TD><TD class=tdTabName><B>&nbsp; aluno &nbsp;</B></TD><TD class=tdTabName>&nbsp;</TD></TR>
<TR class=trTab2><TD nowrap>Logical name</TD><TD colspan=2>aluno</TD></TR>
<TR class=trTab1><TD nowrap>Attributes</TD><TD colspan=2>29</TD></TR>
<TR class=trTab2><TD nowrap>Description</TD><TD colspan=2>&nbsp;</TD></TR>
</TABLE>
<BR>
<TABLE border=1 cellspacing=0 cellpadding=2>
<TR class=trTabTit><TD align=center>PK</TD><TD nowrap>Physical name</TD><TD nowrap>Logical name</TD><TD nowrap>Datatype</TD><TD nowrap>FK Ref.</TD><TD nowrap>Description</TD></TR>
<TR class=trTab1><TD><img src="key29x15.gif" width=29 height=15></TD><TD nowrap>matricula</TD><TD nowrap>aluno.matricula</TD><TD nowrap>CHAR (15)</TD><TD nowrap>&nbsp;</TD><TD>&nbsp;</TD></TR>
<TR class=trTab2><TD><img src="nn29x15.gif" width=29 height=15></TD><TD nowrap>nome</TD><TD nowrap>aluno.nome</TD><TD nowrap>VARCHAR (50)</TD><TD nowrap>&nbsp;</TD><TD>&nbsp;</TD></TR>
<TR class=trTab1><TD><img src="nn29x15.gif" width=29 height=15></TD><TD nowrap>dt_matricula</TD><TD nowrap>aluno.dt_matricula</TD><TD nowrap>DATE</TD><TD nowrap>&nbsp;</TD><TD>&nbsp;</TD></TR>
<TR class=trTab2><TD>&nbsp;</TD><TD nowrap>turno</TD><TD nowrap>aluno.turno</TD><TD nowrap>INT4</TD><TD nowrap>&nbsp;</TD><TD>&nbsp;</TD></TR>
<TR class=trTab1><TD>&nbsp;</TD><TD nowrap>grau</TD><TD nowrap>aluno.grau</TD><TD nowrap>INT4</TD><TD nowrap>&nbsp;</TD><TD>&nbsp;</TD></TR>
<TR class=trTab2><TD>&nbsp;</TD><TD nowrap>serie</TD><TD nowrap>aluno.serie</TD><TD nowrap>INT4</TD><TD nowrap>&nbsp;</TD><TD>&nbsp;</TD></TR>
<TR class=trTab1><TD>&nbsp;</TD><TD nowrap>fator_rh</TD><TD nowrap>aluno.fator_rh</TD><TD nowrap>VARCHAR (5)</TD><TD nowrap>&nbsp;</TD><TD>&nbsp;</TD></TR>
<TR class=trTab2><TD>&nbsp;</TD><TD nowrap>tp_sangue</TD><TD nowrap>aluno.tp_sangue</TD><TD nowrap>VARCHAR (5)</TD><TD nowrap>&nbsp;</TD><TD>&nbsp;</TD></TR>
<TR class=trTab1><TD>&nbsp;</TD><TD nowrap>num_mec</TD><TD nowrap>aluno.num_mec</TD><TD nowrap>VARCHAR (20)</TD><TD nowrap>&nbsp;</TD><TD>&nbsp;</TD></TR>
<TR class=trTab2><TD>&nbsp;</TD><TD nowrap>naturalidade</TD><TD nowrap>aluno.naturalidade</TD><TD nowrap>INT4</TD><TD nowrap>&nbsp;</TD><TD>&nbsp;</TD></TR>
<TR class=trTab1><TD>&nbsp;</TD><TD nowrap>nacionalidade</TD><TD nowrap>aluno.nacionalidade</TD><TD nowrap>INT4</TD><TD nowrap>&nbsp;</TD><TD>&nbsp;</TD></TR>
<TR class=trTab2><TD>&nbsp;</TD><TD nowrap>dt_nascimento</TD><TD nowrap>aluno.dt_nascimento</TD><TD nowrap>DATE</TD><TD nowrap>&nbsp;</TD><TD>&nbsp;</TD></TR>
<TR class=trTab1><TD>&nbsp;</TD><TD nowrap>sexo</TD><TD nowrap>aluno.sexo</TD><TD nowrap>CHAR (1)</TD><TD nowrap>&nbsp;</TD><TD>&nbsp;</TD></TR>
<TR class=trTab2><TD>&nbsp;</TD><TD nowrap>identidade</TD><TD nowrap>aluno.identidade</TD><TD nowrap>CHAR (12)</TD><TD nowrap>&nbsp;</TD><TD>&nbsp;</TD></TR>
<TR class=trTab1><TD>&nbsp;</TD><TD nowrap>orgao_emissor</TD><TD nowrap>aluno.orgao_emissor</TD><TD nowrap>CHAR (10)</TD><TD nowrap>&nbsp;</TD><TD>&nbsp;</TD></TR>
<TR class=trTab2><TD>&nbsp;</TD><TD nowrap>cpf</TD><TD nowrap>aluno.cpf</TD><TD nowrap>CHAR (12)</TD><TD nowrap>&nbsp;</TD><TD>&nbsp;</TD></TR>
<TR class=trTab1><TD>&nbsp;</TD><TD nowrap>endereco</TD><TD nowrap>aluno.endereco</TD><TD nowrap>CHAR (50)</TD><TD nowrap>&nbsp;</TD><TD>&nbsp;</TD></TR>
<TR class=trTab2><TD>&nbsp;</TD><TD nowrap>bairro</TD><TD nowrap>aluno.bairro</TD><TD nowrap>CHAR (50)</TD><TD nowrap>&nbsp;</TD><TD>&nbsp;</TD></TR>
<TR class=trTab1><TD>&nbsp;</TD><TD nowrap>municipio</TD><TD nowrap>aluno.municipio</TD><TD nowrap>CHAR (50)</TD><TD nowrap>&nbsp;</TD><TD>&nbsp;</TD></TR>
<TR class=trTab2><TD>&nbsp;</TD><TD nowrap>cep</TD><TD nowrap>aluno.cep</TD><TD nowrap>CHAR (8)</TD><TD nowrap>&nbsp;</TD><TD>&nbsp;</TD></TR>
<TR class=trTab1><TD>&nbsp;</TD><TD nowrap>obs</TD><TD nowrap>aluno.obs</TD><TD nowrap>TEXT</TD><TD nowrap>&nbsp;</TD><TD>&nbsp;</TD></TR>
<TR class=trTab2><TD>&nbsp;</TD><TD nowrap>bolsista</TD><TD nowrap>aluno.bolsista</TD><TD nowrap>BOOL</TD><TD nowrap>&nbsp;</TD><TD>&nbsp;</TD></TR>
<TR class=trTab1><TD>&nbsp;</TD><TD nowrap>email</TD><TD nowrap>aluno.email</TD><TD nowrap>VARCHAR (60)</TD><TD nowrap>&nbsp;</TD><TD>&nbsp;</TD></TR>
<TR class=trTab2><TD><img src="nn29x15.gif" width=29 height=15></TD><TD nowrap>cod_contratante</TD><TD nowrap>contratante.cod_contratante</TD><TD nowrap>INT4</TD><TD nowrap><a class=aTabRef href="e_10011.htm">contratante</a>.cod_contratante [REL_2]</TD><TD>&nbsp;</TD></TR>
<TR class=trTab1><TD><img src="nn29x15.gif" width=29 height=15></TD><TD nowrap>curso</TD><TD nowrap>cursos.curso</TD><TD nowrap>VARCHAR (5)</TD><TD nowrap><a class=aTabRef href="e_10012.htm">cursos</a>.curso [REL_32]</TD><TD>&nbsp;</TD></TR>
<TR class=trTab2><TD><img src="nn29x15.gif" width=29 height=15></TD><TD nowrap>cod_filiacao</TD><TD nowrap>filiacao.cod_filiacao</TD><TD nowrap>INT4</TD><TD nowrap><a class=aTabRef href="e_10017.htm">filiacao</a>.cod_filiacao [REL_9]</TD><TD>&nbsp;</TD></TR>
<TR class=trTab1><TD><img src="nn29x15.gif" width=29 height=15></TD><TD nowrap>cod_cidade</TD><TD nowrap>aux_cidade.cod_cidade</TD><TD nowrap>INT4</TD><TD nowrap><a class=aTabRef href="e_10003.htm">aux_cidade</a>.cod_cidade [REL_13]</TD><TD>&nbsp;</TD></TR>
<TR class=trTab2><TD><img src="nn29x15.gif" width=29 height=15></TD><TD nowrap>cod_situacao</TD><TD nowrap>situacao.cod_situacao</TD><TD nowrap>INT4</TD><TD nowrap><a class=aTabRef href="e_10027.htm">situacao</a>.cod_situacao [REL_27]</TD><TD>&nbsp;</TD></TR>
<TR class=trTab1><TD>&nbsp;</TD><TD nowrap>estado_civil</TD><TD nowrap>aluno.estado_civil</TD><TD nowrap>INT2</TD><TD nowrap>&nbsp;</TD><TD>&nbsp;</TD></TR>
</TABLE>

<BR>
<TABLE border=1 cellspacing=0 cellpadding=2>
<TR class=trTabTit><TD colspan=4 align=center>Indexes</TD></TR>
<TR class=trTab1><TD colspan=4 nowrap>&gt;&gt; no indexes &lt;&lt;</TD></TR>
</TABLE>

<BR>
<TABLE border=1 cellspacing=0 cellpadding=2>
<TR class=trTabTit><TD>References</TD><TD>Referenced by</TD></TR>
<TR class=trTab1><TD valign=top>
   <a class=aTabRef href="e_10011.htm">contratante</a> [REL_2]
   <BR><a class=aTabRef href="e_10017.htm">filiacao</a> [REL_9]
   <BR><a class=aTabRef href="e_10003.htm">aux_cidade</a> [REL_13]
   <BR><a class=aTabRef href="e_10027.htm">situacao</a> [REL_27]
   <BR><a class=aTabRef href="e_10012.htm">cursos</a> [REL_32]
&nbsp;</TD><TD valign=top>
   <a class=aTabRef href="e_10028.htm">sop</a> [REL_1]
   <BR><a class=aTabRef href="e_10014.htm">diario</a> [REL_3]
   <BR><a class=aTabRef href="e_10020.htm">historico</a> [REL_4]
   <BR><a class=aTabRef href="e_10018.htm">financeiro</a> [REL_5]
   <BR><a class=aTabRef href="e_10019.htm">frequencia</a> [REL_6]
   <BR><a class=aTabRef href="e_10029.htm">telefones</a> [REL_7]
   <BR><a class=aTabRef href="e_10002.htm">alunos_documentos</a> [REL_8]
&nbsp;</TD></TR></TABLE>

<BR><BR>
</BODY>
</HTML>
